TaskPolicyDetail

EntityType | Independent
Logical Entity Name | TaskPolicyDetail
Default Table Name | CmPolicyDetail
Logical Only | NO
Owner | dbo
Definition |
Note |

TaskPolicyDetail Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TaskPolicyDetailId |  | INTEGER | NO |
TaskPolicyId |  | INTEGER | YES |
PolicyRecordType |  | CHAR(1) | NO |
StaffGroupId |  | INTEGER | YES |
TaskTemplateId |  | INTEGER | YES |
IsAllowedToAssign |  | BIT | NO |
IsAllowedToRead |  | BIT | NO |
IsAllowedToEdit |  | BIT | NO |
IsAllowedToClose |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |

TaskPolicyDetail Keys

Key Name | Key Type | Keys
CmPolicyDetail_CmPolicyDetailID_U_C_IDX | PrimaryKey | TaskPolicyDetailId
CmPolicyDetail_CmPolicyID_CanAssign_SyStaffGroupID_N_N_IDX | Inversion Entry | IsAllowedToAssign
CmPolicyDetail_CanRead_CmTemplateID_CmPolicyDetailID_SyStaffGroupID_CmPolicyID_CanAssign_Type_CanEdit_CanClose | Alternate Key | IsAllowedToRead, TaskPolicyDetailId, IsAllowedToAssign, PolicyRecordType, IsAllowedToEdit, IsAllowedToClose
CmPolicyDetail_SyStaffGroupID_CmPolicyID_CanRead_CanClose_CanEdit_N_N_IDX | Inversion Entry | IsAllowedToRead, IsAllowedToClose, IsAllowedToEdit
CmPolicyDetail_Type_CanAssign_CmPolicyID_CmTemplateID_CmPolicyDetailID_SyStaffGroupID_CanRead_CanEdit_CanClose | Alternate Key | PolicyRecordType, IsAllowedToAssign, TaskPolicyDetailId, IsAllowedToRead, IsAllowedToEdit, IsAllowedToClose

TaskPolicyDetail Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StaffGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffGroupId | NO
TaskPolicy | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskPolicyId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTemplateId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

TaskPolicyDetail Check Constraints

Check Constraint Name | CheckConstraint

TaskPolicyDetail Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TaskPolicyDetail | NO |  |  |
Physical (Microsoft SQL Server) dbo.CmPolicyDetail | NO |  |  |

TaskPolicyDetail Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Career Services

TaskPolicyDetail Data Movement Rules

Name | Type | Rule Text/Value